package com.hgkj.cloud.base.dao;

import com.hgkj.cloud.base.domain.TenantTableReports;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;
import java.util.Map;

@Mapper
public interface TenantTableReportsMapper {
    int deleteByPrimaryKey(Long id);

    int insert(TenantTableReports record);

    int insertSelective(TenantTableReports record);

    TenantTableReports selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(TenantTableReports record);

    int updateByPrimaryKey(TenantTableReports record);

    List<Map<String, Object>> listWarningLevelCounts(Map<String, Object> map);

    List<Map<String, Object>> listWarningFactorCounts(Map<String, Object> map);

    List<TenantTableReports> findListWarningReportByLevelVal(Map<String, Object> map);

    List<Map<String, Object>> countFindListWarningReportByLevelVal(Map<String, Object> map);

    List<TenantTableReports> listTableReportsPcByMap(Map<String, Object> map);

    Long listTableReportsByMapCount(Map<String, Object> map);

    List<TenantTableReports> listTableReportsByMap(Map<String, Object> map);

    int deleteTableReport(long id);
    int deleteTableReportBytaskInfoUuid(String uuid);

    TenantTableReports findTableReportByUuid(String uuid);

    List<Map<String, Object>> listTableLevelUser(Map<String, Object> map);

    int listTableLevelUserCount(Map<String, Object> map);

    List<Map<String, Object>> getWarnByUserReport(Map<String, Object> map);

    Long getWarnByUserReportCount(Map<String, Object> map);

    int frameworkWarningTotal(Map<String, Object> map);

    List<Map<String, Object>> frameworkWarningUserCount(Map<String, Object> map);

    Map<String, Object> statWarningMan(Map<String, Object> map);

    List<Map<String, Object>> listCirsesWarningUser(Map<String, Object> map);

    int countListCirsesWarningUser(Map<String, Object> map);

    List<Map<String, Object>> listNomalCirsesWarningUser(Map<String, Object> map);

    int countNomalListCirsesWarningUser(Map<String, Object> map);

    List<Map<String, Object>> latestYearWarningStatistics(Map<String, Object> map);

    List<Map<String, Object>> frameworkGenderStatistics(Map<String, Object> map);

    List<Map<String, Object>> frameworkAgeStatistics(Map<String, Object> map);

    List<Map<String, Object>> statMonthTableReport(Map<String, Object> map);

    List<Map<String, Object>> excelListTableReportsByMap(Map<String, Object> map);

    List<Map<String, Object>> excelListTableReportsDetailsByMap(Map<String, Object> map);// 566

    List<Map<String, Object>> excelListTableReportsDetailsByMap2(Map<String, Object> map);// 399


    List<Map<String, Object>> excelListTableReportsDetailsForPSQI(Map<String, Object> map);

    List<Map<String, Object>> excelListTableReportsDetailsForLSAS(Map<String, Object> map);

    List<Map<String, Object>> excelListTableReportsDetailsForYBOCS(Map<String, Object> map);

    List<Map<String, Object>> excelListTableReportsDetailsForEPQC(Map<String, Object> map);

    List<Map<String, Object>> excelListTableReportsDetailsForEPQA(Map<String, Object> map);

    List<Map<String, Object>> excelListTableReportsDetailsFor16PF(Map<String, Object> map);

    List<Map<String, Object>> excelListTableReportsDetailsForBRMS(Map<String, Object> map);

    List<Map<String, Object>> excelListTableReportsDetailsForSAS(Map<String, Object> map);

    List<Map<String, Object>> excelListTableReportsDetailsForSDS(Map<String, Object> map);

    List<Map<String, Object>> excelListTableReportsDetailsForSF36(Map<String, Object> map);

    List<Map<String, Object>> excelListTableReportsDetailsForBPRS(Map<String, Object> map);

    List<Map<String, Object>> excelListTableReportsDetailsForCMMSE(Map<String, Object> map);

    List<Map<String, Object>> excelListTableReportsDetailsForHAMA(Map<String, Object> map);

    List<Map<String, Object>> excelListTableReportsDetailsForHAMD(Map<String, Object> map);

    List<Map<String, Object>> excelListTableReportsDetailsForSCL90(Map<String, Object> map);

    List<Map<String, Object>> excelListTableReportsDetailsForShirritant(Map<String, Object> map);

    List<Map<String, Object>> excelListTableReportsDetailsForLes(Map<String, Object> map);

    List<Map<String, Object>> getListTableReportsDetailsFor566(Map<String, Object> map);

    List<Map<String, Object>> getListTableReportsDetailsFor399(Map<String, Object> map);

    List<Map<String, Object>> getListTableReportsDetailsForSCL90(Map<String, Object> map);

    List<Map<String, Object>> getListTableReportsDetailsFor16PF(Map<String, Object> map);

    List<Map<String, Object>> getListTableReportsDetailsForSAS(Map<String, Object> map);

    List<Map<String, Object>> getListTableReportsDetailsForSDS(Map<String, Object> map);

    List<Map<String, Object>> getListTableReportsDetailsForHADS(Map<String, Object> map);

    List<Map<String, Object>> getListTableReportsDetailsForEPQC(Map<String, Object> map);

    List<Map<String, Object>> getListTableReportsDetailsForEPQE(Map<String, Object> map);

    List<Map<String, Object>> getSCL90Details(Map<String, Object> map);

    List<Map<String, Object>> getStatisticsCount(Map<String, Object> map);

    List<Map<String, Object>> getReporWarningUserCount(Map<String, Object> map);

    List<Map<String, Object>> frameworkFactorStatistics(Map<String, Object> map);

    List<Map<String, Object>> frameworkAgeFactorStatistics(Map<String, Object> map);

    List<Map<String, Object>> frameworkGenderFactorStatistics(Map<String, Object> map);

    List<Map<String, Object>> ageGenderFactorStatistics(Map<String, Object> map);

    List<Map<String, Object>> frameworkLevelFactorStatistics(Map<String, Object> map);

    List<Map<String, Object>> fGenderFactorStatistics(Map<String, Object> map);

    List<Map<String, Object>> fAgeFactorStatistics(Map<String, Object> map);

    List<Map<String, Object>> getReportByUser(Map<String, Object> map);

    List<TenantTableReports> getReportByUserDA(Map<String, Object> map);

    Long getReportByUserCount(Map<String, Object> map);

    List<Map<String, Object>> frameworkAgeReportStatistics(Map<String, Object> map);

    List<Map<String, Object>> frameworkGenderReportStatistics(Map<String, Object> map);

    List<Map<String, Object>> ageGenderReportStatistics(Map<String, Object> map);

    List<Map<String, Object>> frameworkLevelReportStatistics(Map<String, Object> map);

    List<Map<String, Object>> fGenderReportStatistics(Map<String, Object> map);

    List<Map<String, Object>> fAgeReportStatistics(Map<String, Object> map);

    List<Map<String, Object>> getReportStatisticsUser(Map<String, Object> map);

    int getReportStatisticsUserCount(Map<String, Object> map);

    long countTableReportFinished(Map<String, Object> map);

    long countTableReportWarningByTaskUuid(Map<String, Object> map);

    Map<String ,Object> getFullTableReportsByTaskInfoUuid(String taskInfoUuid);

    List<Map<String ,Object>> countFinishedisZero(String task_uuid);

    List<Map<String, Object>> excelListTableReportsDetailsForAslec(Map<String, Object> map);

    List<Map<String, Object>> excelListTableReportsDetailsForAdhd(Map<String, Object> map);

    List<Map<String, Object>> excelListTableReportsDetailsForXljk(Map<String, Object> map);

    List<Map<String, Object>> excelListTableReportsDetailsForXxdj(Map<String, Object> map);

    List<Map<String, Object>> excelListTableReportsDetailsForKsxwkl(Map<String, Object> map);

    List<Map<String, Object>> excelListTableReportsDetailsForTotal(Map<String, Object> map);

    List<Map<String, Object>> excelListTableReportsDetailsForXxxljkzh(Map<String, Object> map);

    List<Map<String, Object>> excelListTableReportsDetailsForZxxljkzh(Map<String, Object> map);

    List<Map<String, Object>> getAllProposalMagess(Map<String, Object> map);
}